◀ Prev · Parts · Full · Next ▶

Users may write code to define their own connection objects, log providers, transforms, and tasks.cite-ref-14[14]cite-ref-15[15]

SSIS features a programmable object model that allows developers to write their own hosts for package execution. Such a host can respond to events, start and stop packages, and so on. The object model also allows developers to create, store, and load packages, as well as create, destroy, and modify any of the contained objects.

Within limits, SSIS packages can load and call CLI assembly DLLs, providing access to virtually any kind of operation permissible by the .NET CLR.

SSIS can be used on all SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 editions except Express and Workgroup.

◀ Prev · Parts · Full · Next ▶